Database Management System

IMPORTANT

Database Management System: Overview

This topic covers concepts, such as, Network Model, MySQL, Database Management System, Oracle & Database application etc.

Important Questions on Database Management System

EASY
IMPORTANT

The expansion of the E-R diagram is ________.

EASY
IMPORTANT

Which of the following is not a type of database?

MEDIUM
IMPORTANT

Minimal data redundancy means improved _______.

EASY
IMPORTANT

The ____________ contains data name, data type, and length of each field in the database

EASY
IMPORTANT

Which is essentially a business problem, not a data problem?

EASY
IMPORTANT

Which of the following is the expansion of the acronym DBMS?

EASY
IMPORTANT

Which of the following are known as Attribute?

EASY
IMPORTANT

Database Management System (DBMS), which is a data management software cannot use which of the following software for this purpose?

EASY
IMPORTANT

Which of the following are referred to as Tuples?

EASY
IMPORTANT

_____ has the ability to collect information and to perform insertion, deletion and modification of tuples.

EASY
IMPORTANT

Which of the following formal parameter declarations (inside the definition of a PL\SQL procedure or function) are not acceptable?

MEDIUM
IMPORTANT

 The data type and format of every data item in a system is held in a _____.

EASY
IMPORTANT

 Which type of software would you use to store medical records?

MEDIUM
IMPORTANT

The SELECT statement

SELECT 'Hi' FROM DUAL WHERE 1 ! = NULL

outputs

EASY
IMPORTANT

Which of the following SQL commands can be used to add data to a database table?

MEDIUM
IMPORTANT

The SQL statement

SELECT DECODE(2, 2, DECODE(3, 3, 2)) FROM DUAL;

HARD
IMPORTANT

Which of the following joins is also called an 'inner join'?

MEDIUM
IMPORTANT

Choose the correct statements.

MEDIUM
IMPORTANT

The WHERE clause - WHERE city LIKE
'%a_%b'

cannot display